TCP/IP performance is slow

Problem

Overall performance of a back-end tier or of a Full user's iMIS Desktop seems slow.

Solution

The default protocol for SQL Server connections is Named Pipes, so performance might be slowed on a network where TCP/IP is the primary network protocol.

For sites whose primary network protocol is TCP/IP, you usually can enhance performance by using the process described in your SQL Server documentation for setting all hosts and workstations involved in iMIS network traffic to use the TCP/IP protocol instead of the Named Pipes protocol.